WEBVTT

00:01.600 --> 00:05.050
Welcome to the first coding video on financial portfolios.

00:05.050 --> 00:11.680
And before we can create analyze and optimize portfolios we need to import the data and for comparison

00:11.680 --> 00:13.200
and simplicity reasons.

00:13.210 --> 00:19.910
We again use the six stocks Amazon Boeing Disney IBM Coca-Cola and Microsoft.

00:20.230 --> 00:26.920
And we can either download them directly from Yahoo Finance with the White finance library or we can

00:26.920 --> 00:33.940
simply import our index stocks we file and in this case we decide to go for the second alternative.

00:33.940 --> 00:42.310
So first of all we import pandas and then we import our stock data from our CSP file and we create a

00:42.310 --> 00:46.710
daytime index and we save the data and the variable stocks.

00:46.710 --> 00:47.640
So let's have a look here.

00:48.680 --> 00:56.750
And we can see that we have the adjusted close at the close open low and volume for the stocks and us

00:56.780 --> 01:04.100
working with and analyzing portfolios is all about performance and the total return so far this section

01:04.100 --> 01:11.660
here we choose the adjusted close prices so the adjusted close prices reflect Actually the total return

01:11.660 --> 01:14.440
and include also dividend payments.

01:14.780 --> 01:17.750
And let us therefore look at the last five rows.

01:17.840 --> 01:22.390
So we are here we have data from 2000 and thirteen.

01:22.430 --> 01:28.340
The very end of 2013 until the end of 2000 and 18.

01:28.340 --> 01:37.320
And as I said we only selected the adjusted close column and actually we override our stocks data frame.

01:37.370 --> 01:41.150
So this is here the adjusted close for our six stocks.

01:41.750 --> 01:45.680
So that's the data that we are working with and the next videos.

01:45.680 --> 01:54.880
And actually we export here our new data frame and save the data in the new CSP file portfolio of stocks.

01:54.980 --> 02:03.770
So let's do this so now in our file we created the CSP file portfolio stocks and with this we are finished

02:03.770 --> 02:07.070
with this video and I hope to see you also in the next one SPI.